MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Expenses System / Expense Line Items (.txt) < prev

Wrap

FileMaker Pro Database | 1996-01-25 | 109.0 KB | 996 lines | [FMP3/FMP3]

nz.soc! s215 0 nz.soc.green! s678 1 nz.test! s1024 0 nz.wanted! s4461 0 oar.noc! s1029 1 oar.tech! s762 0 oar.users! s36 1 oau.biz! s68 0 oau.config! s33 1 oau.forsale! s186 1 oau.news! s3329 0 oau.test! s31 0 oc.acm! s46 0 oc.eats! s12 0 oc.forsale! s1882 0 oc.general! s2865 0 oc.slug! s162 0 oc.test! s305 0 oc.wanted! s304 1 ogi.general! s213 1 oh.biz! s282 1 oh.cast! s494 0 oh.chem! s55 1 oh.forsale! s1045 1 oh.general! s4934 0 oh.jobs! s763 1 oh.k12! s406 0 HBAM2016AUG95 Pro 3.0 .osc.software! s31 1 oh.test! s464 0 ok.general! s4693 0 ok.groups! s79 0 ok.test! s68 0 okinawa.chat! s105 0 okinawa.events! s19 0 okinawa.food.misc! s47 0 okinawa.general! s38 0 okinawa.life.misc! s14 0 okinawa.mail-lists.nirai-kanai! s173 0 okinawa.misc! s63 0 okinawa.networks! s16 0 okinawa.news.lists! s19 0 okinawa.os.linux! s11 0 okinawa.rec.games! s29 0 okinawa.rec.misc! s14 0 okinawa.rec.music! s18 0 okinawa.rec.travel! s38 0 okinawa.recycle! ckens! s263 0 ont.sf-lovers! s712 1 ont.singles! s10413 0 ont.test! s3290 0 ont.uucp! s1533 1 or.forsale! s17247 0 or.general! s7937 0 or.ojgse.cis641! s20 0 or.politics! s13703 0 or.test! s781 0 orst.cs.261! s76 0 orst.cs.311! s7 0 orst.cs.420! s9 0 orst.cs.581! s39 0 orst.cs.grads! s56 0 orst.cs.jobs! s15 1 orst.cs.undergrad! s1 0 orst.csos.announce! s27 0 orst.csos.public! s55 0 orst.ece.375! s11 0 orst.ece.478! s7 0 orst.engr.announce! s22 0 orst.forsale! s297 0 orst.general! s16 1 orst.jobs! s30 1 orst.mail.firewalls! s1160 1 HBAM3016AUG95@ HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 AMOUNT 1 AMOUNT 2 AMOUNT 3 AMOUNT 4 AMOUNT 5 AMOUNT 6 AMOUNT 7 CREATED BY DATE CREATED DATE MODIFIED EMPLOYEE ID EXPENSE REPORT ID EXPENSE TYPE e RECORD ID SUMMARY TOTAL WEEK TOTAL AMOUNT 1 TOTAL AMOUNT 2 TOTAL AMOUNT 3 TOTAL AMOUNT 4 TOTAL AMOUNT 5 TOTAL AMOUNT 6 TOTAL AMOUNT 7 TOTAL WEEK Expense Report IDB Date CreatedB Date ModifiedB Amount 1B Amount 2B Amount 3B Amount 4B Amount 5B Franz App Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/27/95 Description This file contains all the line items on the expense form. By keeping the expense items in a separate file, you have more flexibility than you would if you used a repeating field. How to use this solution Each expense havs an ID number. This number groups all the line items ion the expense form. How to customize this solution Create your own custom reports to see exactly how much is spent in each category. Yesfter Noarter Yesfter Noarter Amount 6B Amount 7B Expense TypeB Total Amount 1B Total Amount 2B Total Amount 3B Total Amount 4B Total Amount 5B Total Amount 6B Total Amount 7B Total WeekB Created ByB InfoB fA Record IDB Employee IDB Summary Total WeekB A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close !Enter data for Expense Line Items Expense Report ID Expense Expense Line Items Record ID Expenses File... Week Ending Total Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close !Enter data for Expense Line Items Expense Report ID Expense Expense Line Items Record ID Expenses File... Week Ending Totall Employee Employees File... Expenses by TypeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Weekf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo Infop6Click to see more information for an Expense Line Item r Report ID Employee Expense Type Total Week InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Report ID Employee Amount Expenses by Type Expense Type Expenses by Type Page ## Your Own Button Reports View As View As Close Report ID Employee Amount Expenses by Type Expense Type Expenses by Type Page ## (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment VDEFA( (LIST VDEFA( Expense Type ListB Project List FMRLA Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO.Information about the Expense Reports solutionP Info for this Solution bout the Expense Reports solutionP Info for this Solution Your Own ReportB Your Own ReportC Expenses by EmployeeD Expenses by TypeE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Expenses by EmployeeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF 05/09/95Y 10/6/95u 135.6 60.32 Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Business Meals Entertainment 139.3 224.93 145.32 114.62 135.6 Paul Farrah 10/5/95Y 10/5/95u 135.6 60.32{ Taxi, Limousine Taxi, Limousine Lodging Telephone Personal Meals Business Meals Entertainment 139.3 224.93 145.32 114.62 135.6 Paul Farrah 10/5/95Y 10/5/95u 54.3w 135.6x 60.32 Lodging Taxi, Limousine Lodging Telephone Personal Meals Business Meals Entertainment 139.3 224.93 145.32 Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Report ID Expense Type Amount Expenses by Employee Employee Expenses by Employee Page ## Your Own Button Reports View As View As Close Report ID Expense Type Amount Expenses by Employee Employee Expenses by Employee Page ## 1414.55 647.06 Sort by Expense Report ID Sort by Date of End of Week Sort by Last Name Sort by Expense Type Expenses by Type Expenses by Employee Open Script Sort by Expense Report ID 114.62 135.6 Paul Farrah 10/5/95Y 10/5/95 54.3w 135.6 60.32 @ Telephone Taxi, Limousine Lodging Telephone Personal Meals Business Meals Entertainment 139.3 224.93 145.32 114.62 135.6 Paul Farrah 10/5/95Y 10/5/95 135.6x 60.32 Personal Meals Taxi, Limousine Lodging Telephone Personal Meals Business Meals Entertainment 139.3 224.93 145.32 114.62 135.6 Paul Farrah 10/5/95Y 10/5/95 54.30 135.6 60.32 60.32 Business Meals Taxi, Limousine Lodging Telephone Personal Meals Business Meals Entertainment 139.3 224.93 145.32 114.62 114.62 135.6 Paul Farrah 10/5/95Y 10/5/95w 135.60 Entertainment 135.6 Paul Farrah 10/5/95Y 10/5/95v Personal Meals Paul Farrah 10/5/95Y 10/6/95x 4.50y Tolls and Parking Paul Farrah 10/5/95Y 10/6/95x 25.70y 32.48 Personal Meals 58.18 Paul Farrah 10/6/95Y 10/6/95x Lodging Paul Farrah 10/6/95Y 10/6/95x @ Telephone Paul Farrah 10/6/95Y 10/6/95x 129.5y 129.5 Air, Rail, Bus Paul Farrah Expenses by Type Sort by Last Name Sort by Date of End of Week Open Script You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif wwwwww ffffff UUUUUU DDDDDD wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw :RPTH FPTHA:HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 7RPTH FPTHA7HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Names.fp3 NAMEA Employee Names.fp3 RPTHA Employee Names.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 2RPTH FPTHA2HARDDISK:CONSULT:ClarisII:v4:Employee Expenses.fp3 NAMEA Employee Expenses.fp3 RPTHA Employee Expenses.fp3 WSPCA C:\CONSULT\ClarisII\v4\ VDEFA( (LIST VDEFA( Expense Type ListB Project List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww Employee ExpensesB Employee Names FMRLA FMRLA Sort by Expense Type Expenses by Employee )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) A Form View A List View Expenses by Type Information Report Menu Expenses by Employee A Form ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Sort by Expense Report ID Sort by Date of End of Week Sort by Last Name Sort by Expense Type Expenses by Type Expenses by Employee Open Script Sort by Expense Report ID Sort by Expense Report ID